CREATE OR REPLACE PACKAGE DISCOUNT_USER.insertcouponfeed_pkg AS

    
    
    PROCEDURE InsertUpdateDISCOUNTS_LNKSHR(
    
    p_advertisername IN LINKSHARE_DISCOUNTS.ADVERTISER_NAME%TYPE,
    p_advertiserid IN LINKSHARE_DISCOUNTS.ADVERTISER_ID%TYPE,
    p_offerdescription IN LINKSHARE_DISCOUNTS.OFFER_DESCRIPTION%TYPE,
    p_offerstartdate IN LINKSHARE_DISCOUNTS.OFFER_START_DATE%TYPE,
    p_offerenddate IN LINKSHARE_DISCOUNTS.OFFER_END_DATE%TYPE,
    p_impressionpixel IN LINKSHARE_DISCOUNTS.IMPRESSION_PIXEL%TYPE,
    p_networkid IN LINKSHARE_DISCOUNTS.NETWORK_ID%TYPE,
    p_network IN LINKSHARE_DISCOUNTS.NETWORK%TYPE,
    p_couponcode IN LINKSHARE_DISCOUNTS.COUPON_CODE%TYPE,
    p_offerid IN LINKSHARE_DISCOUNTS.OFFER_ID%TYPE,
    p_clickurl IN LINKSHARE_DISCOUNTS.CLICK_URL%TYPE);
    
    
    PROCEDURE InsertUpdateLNKSHR_SUBCAT(
    p_catid IN LINKSHARE_CATEGORY.CATEGORY_ID%TYPE,
    p_catname IN LINKSHARE_CATEGORY.CATEGORY_NAME%TYPE,
    p_offerid IN LINKSHARE_DISCOUNTS.OFFER_ID%TYPE);
    
    PROCEDURE InsertUpdateLNKSHR_PROMO(
    p_promoid IN LINKSHARE_PROMOTYPE.PROMOTION_TYPE_ID%TYPE,
    p_promoname IN LINKSHARE_PROMOTYPE.PROMOTION_NAME%TYPE,
    p_offerid IN LINKSHARE_DISCOUNTS.OFFER_ID%TYPE);
 
END insertcouponfeed_pkg;
/